<?php
//Sql eka gaththe me function eken getEmpIncomeReport($empno,$year,$month)
$income=$_POST['txtIncome'];
$sql="select subject_code.subject,
subject_code.grade,
sum(payment.p_fee) as income from 
payment,subject_code,class_sched 
where class_sched.emp_no='$empno' and class_sched.sub_gr=subject_code.sub_gr and class_sched.sub_gr=payment.sub_gr and month(payment.paid_date)='$month' and year(payment.paid_date)='$year' and   
payment.sub_gr=subject_code.sub_gr and sum(payment.p_fee)> $income
group by payment.sub_gr";
//line number 9 wala(query eke anthima kallata issella eke) aluthin add kara sum(payment.p_fee)> $income 
//$income variable ekata '' dalath balanna wada kare nathnam
?>

//thawa widiyaka thiyanawa karanna 
// eka mama ayeth mekata dannam

report eke rows gahadii income eke text box eke gaththa value variable ekak thiyanagena
 genapu data gahaddi row eka wadiina kalin income eka text box eke dana ekata wada wadinam withara mulu record ekama echo karanna
 oka karanna ona loop eka athule if ekak dala

